package com.first.agent.dao;

import com.first.agent.pojo.AdvanceCharge;
import com.first.agent.pojo.AgentCustomer;
import com.first.agent.pojo.Product;
import com.first.agent.pojo.User;

import java.sql.SQLException;
import java.util.List;

/**
 * Created with IntelliJ IDEA.
 * User: ljc
 * Date: 2022/11/15 11:03
 * Description:  报表管理Dao层
 * Version: V1.0
 */
public interface ReportDao {
    /**
     * 生成代理商余额报表
     * @param start
     * @param end
     * @return
     * @throws SQLException
     */
    List<User> findAgentBalance(String start, String end) throws SQLException;

    /**
     * 预付款流水报表
     * @param start
     * @param end
     * @return
     * @throws SQLException
     */
    List<AdvanceCharge> findCharge(String start,String end) throws SQLException;

    /**
     * 代理商流水报表
     * @param start
     * @param end
     * @return
     * @throws SQLException
     */
    List<AdvanceCharge> findAgent(String start,String end) throws SQLException;

    /**
     * 查找产品分类数量/金额报表
     * @param start
     * @param end
     * @return
     * @throws SQLException
     */
    List<Product> findProduct(String start,String end) throws SQLException;

}
